package com.apexedu.eas.dao.impl;

import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

import com.apexedu.eas.annotation.Query;
import com.apexedu.eas.entity.test.Sjzjgl;
import com.apexedu.framework.util.Pager;

/**
 * 数据子集管理DAO
 * 
 * @author Dipsy
 * 
 */
@Repository
public class SjzjglDao extends BasisDao<Sjzjgl, Integer> {

	/**
	 * 查询分页
	 * 
	 * @return
	 */
	@Query(value = "select * from @Sjzjgl", replace = true, pager = true)
	public List<Sjzjgl> queryByPage(Pager pager) {
		return null;
	}

	/**
	 * 计数查询
	 * 
	 * @return
	 */
	@Query(value = "select count(1) from @Sjzjgl", replace = true, count = true)
	public Integer queryCount() {
		return null;
	}

	/**
	 * 修改
	 * 
	 * @return
	 */
	@Query(value = "update @Sjzjgl set sjzjmc=?,sjkyhm=? where id=?", replace = true, update = true)
	public Integer doUpdate(String sjzjmc, String sjkyhm, String id) {
		return null;
	}

	/**
	 * 根据编号查询单条记录
	 * 
	 * @param id
	 * @return
	 */
	@Query(value = "select * from @Sjzjgl where id=?", replace = true)
	public List<Map<String, String>> queryForForm(String id) {
		return null;
	}
	
	/**
	 * 查询最大一条记录 用作新增之前
	 * @return
	 */
	@Query(value="select Max(id) from @Sjzjgl",replace=true)
	public Object queryMaxId(){
		return null;
	}
	
	/**
	 * 新增记录
	 * @param id
	 * @param sjzjmc
	 * @param sjkyhm
	 * @return
	 */
	@Query(value="insert into @Sjzjgl (id,sjzjmc,sjkyhm) values(?,?,?)",update=true,replace=true)
	public Integer doInsert(Integer id,String sjzjmc,String sjkyhm){
		return null;
	}

	/**
	 * 删除记录
	 * @param id
	 * @return
	 */
	@Query(value="delete @Sjzjgl where id=?",replace=true)
	public Integer doDelete(String id){
		return null;
	}
}




